JBoss Deployment: Windows XP and SQL Server

• For all deployments Java 1.5.0_15 or newer should be used
• A xml file with the following contents will need to be create and named sqlrep-ds.xml:

  <?xml version="1.0" encoding="UTF-8"?> 
  <datasources> 
   <local-tx-datasource> 
   <jndi-name>jdbc/ExpereDoc</jndi-name> 
   <connection-
  url>jdbc:jtds:sqlserver://MACHINE_NAME:1433;DatabaseName=DATABASE_NAME</connection-url> 
   <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class> 
   <user-name>DATABASE_USERNAME</user-name> 
   <password>DATABASE_PASSWORD</password> 
  </local-tx-datasource> 
  </datasources>

  • MACHINE_NAME will be substituted by the machine name on which the database is installed.
  • DATABASE_NAME will be substituted by the name of the SQL Server database.
  • DATABASE_USERNAME will be substituted by the SQL Server database user name.
  • DATABASE_PASSWORD will be substituted by the SQL Server database password.

For more information, see the following:

• JBoss 5.0.1.GA
• JBoss 4.0.5.GA